﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="kladrDataSet" targetNamespace="http://tempuri.org/kladrDataSet.xsd" xmlns:mstns="http://tempuri.org/kladrDataSet.xsd" xmlns="http://tempuri.org/kladrDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="1" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="testlinqConnectionString1" IsAppSettingsProperty="true" Modifier="Assembly" Name="testlinqConnectionString1 (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.KLADR.Properties.Settings.GlobalReference.Default.testlinqConnectionString1" Provider="System.Data.SqlClient" />
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="kladrConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="kladrConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.KLADR.Properties.Settings.GlobalReference.Default.kladrConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="domaTableAdapter" GeneratorDataComponentClassName="domaTableAdapter" Name="doma" UserDataComponentName="domaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="kladrConnectionString (Settings)" DbObjectName="testlinq.Kladr.doma" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Kladr].[doma] WHERE (((@IsNull_name = 1 AND [name] IS NULL) OR ([name] = @Original_name)) AND ((@IsNull_korp = 1 AND [korp] IS NULL) OR ([korp] = @Original_korp)) AND ((@IsNull_socr = 1 AND [socr] IS NULL) OR ([socr] = @Original_socr)) AND ([code] = @Original_code) AND ((@IsNull_index = 1 AND [index] IS NULL) OR ([index] = @Original_index)) AND ((@IsNull_gninmb = 1 AND [gninmb] IS NULL) OR ([gninmb] = @Original_gninmb)) AND ((@IsNull_uno = 1 AND [uno] IS NULL) OR ([uno] = @Original_uno)) AND ((@IsNull_ocatd = 1 AND [ocatd] IS NULL) OR ([ocatd] = @Original_ocatd)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_name" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_korp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="korp" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_korp" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="korp" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_socr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="socr" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_socr" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="socr" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_code" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_index" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="index" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_index" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="index" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_gninmb" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="gninmb" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_gninmb" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="gninmb" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_uno" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="uno" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_uno" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="uno" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ocatd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ocatd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ocatd" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ocatd" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Kladr].[doma] ([name], [korp], [socr], [code], [index], [gninmb], [uno], [ocatd]) VALUES (@name, @korp, @socr, @code, @index, @gninmb, @uno, @ocatd);
SELECT name, korp, socr, code, [index], gninmb, uno, ocatd FROM Kladr.doma WHERE (code = @code)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@name" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@korp" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="korp" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@socr" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="socr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@code" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@index" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="index" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@gninmb" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="gninmb" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@uno" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="uno" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ocatd" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ocatd" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT name, korp, socr, code, [index], gninmb, uno, ocatd FROM Kladr.doma</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Kladr].[doma] SET [name] = @name, [korp] = @korp, [socr] = @socr, [code] = @code, [index] = @index, [gninmb] = @gninmb, [uno] = @uno, [ocatd] = @ocatd WHERE (((@IsNull_name = 1 AND [name] IS NULL) OR ([name] = @Original_name)) AND ((@IsNull_korp = 1 AND [korp] IS NULL) OR ([korp] = @Original_korp)) AND ((@IsNull_socr = 1 AND [socr] IS NULL) OR ([socr] = @Original_socr)) AND ([code] = @Original_code) AND ((@IsNull_index = 1 AND [index] IS NULL) OR ([index] = @Original_index)) AND ((@IsNull_gninmb = 1 AND [gninmb] IS NULL) OR ([gninmb] = @Original_gninmb)) AND ((@IsNull_uno = 1 AND [uno] IS NULL) OR ([uno] = @Original_uno)) AND ((@IsNull_ocatd = 1 AND [ocatd] IS NULL) OR ([ocatd] = @Original_ocatd)));
SELECT name, korp, socr, code, [index], gninmb, uno, ocatd FROM Kladr.doma WHERE (code = @code)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@name" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@korp" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="korp" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@socr" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="socr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@code" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@index" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="index" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@gninmb" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="gninmb" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@uno" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="uno" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ocatd" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ocatd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_name" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_korp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="korp" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_korp" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="korp" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_socr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="socr" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_socr" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="socr" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_code" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_index" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="index" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_index" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="index" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_gninmb" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="gninmb" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_gninmb" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="gninmb" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_uno" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="uno" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_uno" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="uno" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ocatd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ocatd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ocatd" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ocatd" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="name" DataSetColumn="name" />
              <Mapping SourceColumn="korp" DataSetColumn="korp" />
              <Mapping SourceColumn="socr" DataSetColumn="socr" />
              <Mapping SourceColumn="code" DataSetColumn="code" />
              <Mapping SourceColumn="index" DataSetColumn="index" />
              <Mapping SourceColumn="gninmb" DataSetColumn="gninmb" />
              <Mapping SourceColumn="uno" DataSetColumn="uno" />
              <Mapping SourceColumn="ocatd" DataSetColumn="ocatd" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="kladrTableAdapter" GeneratorDataComponentClassName="kladrTableAdapter" Name="kladr" UserDataComponentName="kladrTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="kladrConnectionString (Settings)" DbObjectName="testlinq.Kladr.kladr" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Kladr].[kladr] WHERE (((@IsNull_name = 1 AND [name] IS NULL) OR ([name] = @Original_name)) AND ((@IsNull_socr = 1 AND [socr] IS NULL) OR ([socr] = @Original_socr)) AND ([code] = @Original_code) AND ((@IsNull_index = 1 AND [index] IS NULL) OR ([index] = @Original_index)) AND ((@IsNull_gninmb = 1 AND [gninmb] IS NULL) OR ([gninmb] = @Original_gninmb)) AND ((@IsNull_uno = 1 AND [uno] IS NULL) OR ([uno] = @Original_uno)) AND ((@IsNull_ocatd = 1 AND [ocatd] IS NULL) OR ([ocatd] = @Original_ocatd)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_name" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_socr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="socr" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_socr" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="socr" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_code" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_index" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="index" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_index" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="index" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_gninmb" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="gninmb" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_gninmb" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="gninmb" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_uno" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="uno" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_uno" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="uno" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ocatd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ocatd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ocatd" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ocatd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_status" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_status" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Kladr].[kladr] ([name], [socr], [code], [index], [gninmb], [uno], [ocatd], [status]) VALUES (@name, @socr, @code, @index, @gninmb, @uno, @ocatd, @status);
SELECT name, socr, code, [index], gninmb, uno, ocatd, status FROM Kladr.kladr WHERE (code = @code)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@name" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@socr" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="socr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@code" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@index" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="index" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@gninmb" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="gninmb" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@uno" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="uno" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ocatd" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ocatd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@status" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        UPPER(name) AS name, UPPER(socr) AS socr, code, [index], gninmb, uno, ocatd, status
FROM            Kladr.kladr
WHERE        (code LIKE { fn CONCAT(@region, '___00000000') }) AND (NOT (code = { fn CONCAT(@region, '00000000000') }))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="region" ColumnName="code" DataSourceName="testlinq.Kladr.kladr" DataTypeServer="nchar(13)" DbType="AnsiString" Direction="Input" ParameterName="@region" Precision="0" ProviderType="VarChar" Scale="0" Size="2" SourceColumn="code" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Kladr].[kladr] SET [name] = @name, [socr] = @socr, [code] = @code, [index] = @index, [gninmb] = @gninmb, [uno] = @uno, [ocatd] = @ocatd, [status] = @status WHERE (((@IsNull_name = 1 AND [name] IS NULL) OR ([name] = @Original_name)) AND ((@IsNull_socr = 1 AND [socr] IS NULL) OR ([socr] = @Original_socr)) AND ([code] = @Original_code) AND ((@IsNull_index = 1 AND [index] IS NULL) OR ([index] = @Original_index)) AND ((@IsNull_gninmb = 1 AND [gninmb] IS NULL) OR ([gninmb] = @Original_gninmb)) AND ((@IsNull_uno = 1 AND [uno] IS NULL) OR ([uno] = @Original_uno)) AND ((@IsNull_ocatd = 1 AND [ocatd] IS NULL) OR ([ocatd] = @Original_ocatd)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)));
SELECT name, socr, code, [index], gninmb, uno, ocatd, status FROM Kladr.kladr WHERE (code = @code)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@name" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@socr" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="socr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@code" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@index" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="index" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@gninmb" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="gninmb" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@uno" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="uno" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ocatd" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ocatd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@status" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_name" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_socr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="socr" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_socr" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="socr" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_code" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_index" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="index" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_index" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="index" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_gninmb" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="gninmb" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_gninmb" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="gninmb" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_uno" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="uno" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_uno" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="uno" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ocatd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ocatd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ocatd" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ocatd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_status" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_status" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="name" DataSetColumn="name" />
              <Mapping SourceColumn="socr" DataSetColumn="socr" />
              <Mapping SourceColumn="code" DataSetColumn="code" />
              <Mapping SourceColumn="index" DataSetColumn="index" />
              <Mapping SourceColumn="gninmb" DataSetColumn="gninmb" />
              <Mapping SourceColumn="uno" DataSetColumn="uno" />
              <Mapping SourceColumn="ocatd" DataSetColumn="ocatd" />
              <Mapping SourceColumn="status" DataSetColumn="status" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="kladrConnectionString (Settings)" DbObjectName="testlinq.Kladr.kladr" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillCityByCode" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataCityByCode" GeneratorSourceName="FillCityByCode" GetMethodModifier="Public" GetMethodName="GetDataCityByCode" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataCityByCode" UserSourceName="FillCityByCode">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        UPPER(name) AS name, UPPER(socr) AS socr, code, [index], gninmb, uno, ocatd, status
FROM            Kladr.kladr
WHERE        (code = @region + @district + @city + '00000')</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="region" ColumnName="code" DataSourceName="testlinq.Kladr.kladr" DataTypeServer="nchar(13)" DbType="String" Direction="Input" ParameterName="@region" Precision="0" ProviderType="NChar" Scale="0" Size="2" SourceColumn="code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="district" ColumnName="code" DataSourceName="testlinq.Kladr.kladr" DataTypeServer="nchar(13)" DbType="String" Direction="Input" ParameterName="@district" Precision="0" ProviderType="NChar" Scale="0" Size="3" SourceColumn="code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="city" ColumnName="code" DataSourceName="testlinq.Kladr.kladr" DataTypeServer="nchar(13)" DbType="String" Direction="Input" ParameterName="@city" Precision="0" ProviderType="NChar" Scale="0" Size="3" SourceColumn="code" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="kladrConnectionString (Settings)" DbObjectName="testlinq.Kladr.kladr" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillCityByRegionDistrict" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataCityByRegionDistrict" GeneratorSourceName="FillCityByRegionDistrict" GetMethodModifier="Public" GetMethodName="GetDataCityByRegionDistrict" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataCityByRegionDistrict" UserSourceName="FillCityByRegionDistrict">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        UPPER(name) AS name, UPPER(socr) AS socr, code, [index], gninmb, uno, ocatd, status
FROM            Kladr.kladr
WHERE        (code LIKE @region +  @district+'___00000') AND (NOT (code = @region+ @district+'00000000')) order by name</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="region" ColumnName="code" DataSourceName="testlinq.Kladr.kladr" DataTypeServer="nchar(13)" DbType="String" Direction="Input" ParameterName="@region" Precision="0" ProviderType="NChar" Scale="0" Size="2" SourceColumn="code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="district" ColumnName="code" DataSourceName="testlinq.Kladr.kladr" DataTypeServer="nchar(13)" DbType="String" Direction="Input" ParameterName="@district" Precision="0" ProviderType="NChar" Scale="0" Size="3" SourceColumn="code" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="kladrConnectionString (Settings)" DbObjectName="testlinq.Kladr.kladr" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillCityByRegionDistrictName" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataCityByRegionDistrictName" GeneratorSourceName="FillCityByRegionDistrictName" GetMethodModifier="Public" GetMethodName="GetDataCityByRegionDistrictName" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataCityByRegionDistrictName" UserSourceName="FillCityByRegionDistrictName">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        UPPER(name) AS name, UPPER(socr) AS socr, code, [index], gninmb, uno, ocatd, status
FROM            Kladr.kladr
WHERE        (code LIKE @region +  @district+'___00000') AND (NOT (code = @region+ @district+'00000000')) and UPPER(name) like @name order by name</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="region" ColumnName="code" DataSourceName="testlinq.Kladr.kladr" DataTypeServer="nchar(13)" DbType="String" Direction="Input" ParameterName="@region" Precision="0" ProviderType="NChar" Scale="0" Size="2" SourceColumn="code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="district" ColumnName="code" DataSourceName="testlinq.Kladr.kladr" DataTypeServer="nchar(13)" DbType="String" Direction="Input" ParameterName="@district" Precision="0" ProviderType="NChar" Scale="0" Size="3" SourceColumn="code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="name" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="AnsiString" Direction="Input" ParameterName="@name" Precision="0" Scale="0" Size="1024" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="kladrConnectionString (Settings)" DbObjectName="testlinq.Kladr.kladr" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillDistrictByCode" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataDistrictByCode" GeneratorSourceName="FillDistrictByCode" GetMethodModifier="Public" GetMethodName="GetDataDistrictByCode" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataDistrictByCode" UserSourceName="FillDistrictByCode">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        UPPER(name) AS name, UPPER(socr) AS socr, code, [index], gninmb, uno, ocatd, status
FROM            Kladr.kladr
WHERE        code= @region+@distric+ '00000000'</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="region" ColumnName="code" DataSourceName="testlinq.Kladr.kladr" DataTypeServer="nchar(13)" DbType="String" Direction="Input" ParameterName="@region" Precision="0" ProviderType="NChar" Scale="0" Size="2" SourceColumn="code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="distric" ColumnName="code" DataSourceName="testlinq.Kladr.kladr" DataTypeServer="nchar(13)" DbType="String" Direction="Input" ParameterName="@distric" Precision="0" ProviderType="NChar" Scale="0" Size="3" SourceColumn="code" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="kladrConnectionString (Settings)" DbObjectName="testlinq.Kladr.kladr" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillDistrictByRegion" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataDistrictByRegion" GeneratorSourceName="FillDistrictByRegion" GetMethodModifier="Public" GetMethodName="GetDataDistrictByRegion" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataDistrictByRegion" UserSourceName="FillDistrictByRegion">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        UPPER(name) AS name, UPPER(socr) AS socr, code, [index], gninmb, uno, ocatd, status
FROM            Kladr.kladr
WHERE        (code LIKE { fn CONCAT(@region, '___00000000') }) AND (NOT (code = { fn CONCAT(@region, '00000000000') })) order by name</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="region" ColumnName="code" DataSourceName="testlinq.Kladr.kladr" DataTypeServer="nchar(13)" DbType="AnsiString" Direction="Input" ParameterName="@region" Precision="0" ProviderType="NChar" Scale="0" Size="2" SourceColumn="code" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="kladrConnectionString (Settings)" DbObjectName="testlinq.Kladr.kladr" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillDistrictByRegionAndName" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataDistrictByRegionAndName" GeneratorSourceName="FillDistrictByRegionAndName" GetMethodModifier="Public" GetMethodName="GetDataDistrictByRegionAndName" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataDistrictByRegionAndName" UserSourceName="FillDistrictByRegionAndName">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        UPPER(name) AS name, UPPER(socr) AS socr, code, [index], gninmb, uno, ocatd, status
FROM            Kladr.kladr
WHERE        (code LIKE { fn CONCAT(@region, '___00000000') }) AND (NOT (code = { fn CONCAT(@region, '00000000000') })) and (UPPER(name) like @name_district) order by name</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="region" ColumnName="code" DataSourceName="testlinq.Kladr.kladr" DataTypeServer="nchar(13)" DbType="AnsiString" Direction="Input" ParameterName="@region" Precision="0" ProviderType="NChar" Scale="0" Size="2" SourceColumn="code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="name_district" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="AnsiString" Direction="Input" ParameterName="@name_district" Precision="0" Scale="0" Size="1024" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="kladrConnectionString (Settings)" DbObjectName="testlinq.Kladr.kladr" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillRegion" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataRegion" GeneratorSourceName="FillRegion" GetMethodModifier="Public" GetMethodName="GetDataRegion" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataRegion" UserSourceName="FillRegion">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT upper(name) as name, upper(socr) as socr, code, [index], gninmb, uno, ocatd, status FROM Kladr.kladr where code like '__00000000000'</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="kladrConnectionString (Settings)" DbObjectName="testlinq.Kladr.kladr" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillRegionByCode" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataRegionByCode" GeneratorSourceName="FillRegionByCode" GetMethodModifier="Public" GetMethodName="GetDataRegionByCode" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataRegionByCode" UserSourceName="FillRegionByCode">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        UPPER(name) AS name, UPPER(socr) AS socr, code, [index], gninmb, uno, ocatd, status
FROM            Kladr.kladr
WHERE        code = @region + '00000000000'</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="region" ColumnName="code" DataSourceName="testlinq.Kladr.kladr" DataTypeServer="nchar(13)" DbType="String" Direction="Input" ParameterName="@region" Precision="0" ProviderType="NChar" Scale="0" Size="2" SourceColumn="code" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="kladrConnectionString (Settings)" DbObjectName="DatabaseKLADR.Kladr.kladr" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillRegionByName" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataRegionByName" GeneratorSourceName="FillRegionByName" GetMethodModifier="Public" GetMethodName="GetDataRegionByName" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataRegionByName" UserSourceName="FillRegionByName">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        UPPER(name) AS name, UPPER(socr) AS socr, code, [index], gninmb, uno, ocatd, status
FROM            Kladr.kladr
WHERE        (code LIKE '__00000000000') AND (UPPER(name) LIKE @name)
ORDER BY name</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="name" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="AnsiString" Direction="Input" ParameterName="@name" Precision="0" Scale="0" Size="1024" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="kladrConnectionString (Settings)" DbObjectName="testlinq.Kladr.kladr" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillTownByCode" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataTownByCode" GeneratorSourceName="FillTownByCode" GetMethodModifier="Public" GetMethodName="GetDataTownByCode" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataTownByCode" UserSourceName="FillTownByCode">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        UPPER(name) AS name, UPPER(socr) AS socr, code, [index], gninmb, uno, ocatd, status
FROM            Kladr.kladr
WHERE        code = @region + @district + '000'+@town+'00'</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="region" ColumnName="code" DataSourceName="testlinq.Kladr.kladr" DataTypeServer="nchar(13)" DbType="String" Direction="Input" ParameterName="@region" Precision="0" ProviderType="NChar" Scale="0" Size="2" SourceColumn="code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="district" ColumnName="code" DataSourceName="testlinq.Kladr.kladr" DataTypeServer="nchar(13)" DbType="String" Direction="Input" ParameterName="@district" Precision="0" ProviderType="NChar" Scale="0" Size="3" SourceColumn="code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="town" ColumnName="code" DataSourceName="testlinq.Kladr.kladr" DataTypeServer="nchar(13)" DbType="String" Direction="Input" ParameterName="@town" Precision="0" ProviderType="NChar" Scale="0" Size="3" SourceColumn="code" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="kladrConnectionString (Settings)" DbObjectName="testlinq.Kladr.kladr" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillTownByRegionDistrict" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataTownByRegionDistrict" GeneratorSourceName="FillTownByRegionDistrict" GetMethodModifier="Public" GetMethodName="GetDataTownByRegionDistrict" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataTownByRegionDistrict" UserSourceName="FillTownByRegionDistrict">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        UPPER(name) AS name, UPPER(socr) AS socr, code, [index], gninmb, uno, ocatd, status
FROM            Kladr.kladr
WHERE        (code LIKE @region + @district + '000___00') AND (NOT (code = @region + @district + '00000000')) order by name</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="region" ColumnName="code" DataSourceName="testlinq.Kladr.kladr" DataTypeServer="nchar(13)" DbType="String" Direction="Input" ParameterName="@region" Precision="0" ProviderType="NChar" Scale="0" Size="2" SourceColumn="code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="district" ColumnName="code" DataSourceName="testlinq.Kladr.kladr" DataTypeServer="nchar(13)" DbType="String" Direction="Input" ParameterName="@district" Precision="0" ProviderType="NChar" Scale="0" Size="3" SourceColumn="code" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="kladrConnectionString (Settings)" DbObjectName="testlinq.Kladr.kladr" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillTownByRegionDistrictName" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataTownByRegionDistrictName" GeneratorSourceName="FillTownByRegionDistrictName" GetMethodModifier="Public" GetMethodName="GetDataTownByRegionDistrictName" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataTownByRegionDistrictName" UserSourceName="FillTownByRegionDistrictName">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        UPPER(name) AS name, UPPER(socr) AS socr, code, [index], gninmb, uno, ocatd, status
FROM            Kladr.kladr
WHERE        (code LIKE @region + @district + '000___00') AND (NOT (code = @region + @district + '00000000')) and UPPER(name) like @name order by name</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="region" ColumnName="code" DataSourceName="testlinq.Kladr.kladr" DataTypeServer="nchar(13)" DbType="String" Direction="Input" ParameterName="@region" Precision="0" ProviderType="NChar" Scale="0" Size="2" SourceColumn="code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="district" ColumnName="code" DataSourceName="testlinq.Kladr.kladr" DataTypeServer="nchar(13)" DbType="String" Direction="Input" ParameterName="@district" Precision="0" ProviderType="NChar" Scale="0" Size="3" SourceColumn="code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="name" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="AnsiString" Direction="Input" ParameterName="@name" Precision="0" Scale="0" Size="1024" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="streetTableAdapter" GeneratorDataComponentClassName="streetTableAdapter" Name="street" UserDataComponentName="streetTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="kladrConnectionString (Settings)" DbObjectName="testlinq.Kladr.street" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Kladr].[street] WHERE (((@IsNull_name = 1 AND [name] IS NULL) OR ([name] = @Original_name)) AND ((@IsNull_socr = 1 AND [socr] IS NULL) OR ([socr] = @Original_socr)) AND ([code] = @Original_code) AND ((@IsNull_index = 1 AND [index] IS NULL) OR ([index] = @Original_index)) AND ((@IsNull_gninmb = 1 AND [gninmb] IS NULL) OR ([gninmb] = @Original_gninmb)) AND ((@IsNull_uno = 1 AND [uno] IS NULL) OR ([uno] = @Original_uno)) AND ((@IsNull_ocatd = 1 AND [ocatd] IS NULL) OR ([ocatd] = @Original_ocatd)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_name" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_socr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="socr" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_socr" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="socr" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_code" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_index" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="index" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_index" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="index" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_gninmb" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="gninmb" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_gninmb" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="gninmb" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_uno" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="uno" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_uno" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="uno" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ocatd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ocatd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ocatd" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ocatd" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Kladr].[street] ([name], [socr], [code], [index], [gninmb], [uno], [ocatd]) VALUES (@name, @socr, @code, @index, @gninmb, @uno, @ocatd);
SELECT name, socr, code, [index], gninmb, uno, ocatd FROM Kladr.street WHERE (code = @code)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@name" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@socr" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="socr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@code" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@index" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="index" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@gninmb" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="gninmb" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@uno" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="uno" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ocatd" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ocatd" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT name, socr, code, [index], gninmb, uno, ocatd FROM Kladr.street</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Kladr].[street] SET [name] = @name, [socr] = @socr, [code] = @code, [index] = @index, [gninmb] = @gninmb, [uno] = @uno, [ocatd] = @ocatd WHERE (((@IsNull_name = 1 AND [name] IS NULL) OR ([name] = @Original_name)) AND ((@IsNull_socr = 1 AND [socr] IS NULL) OR ([socr] = @Original_socr)) AND ([code] = @Original_code) AND ((@IsNull_index = 1 AND [index] IS NULL) OR ([index] = @Original_index)) AND ((@IsNull_gninmb = 1 AND [gninmb] IS NULL) OR ([gninmb] = @Original_gninmb)) AND ((@IsNull_uno = 1 AND [uno] IS NULL) OR ([uno] = @Original_uno)) AND ((@IsNull_ocatd = 1 AND [ocatd] IS NULL) OR ([ocatd] = @Original_ocatd)));
SELECT name, socr, code, [index], gninmb, uno, ocatd FROM Kladr.street WHERE (code = @code)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@name" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@socr" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="socr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@code" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@index" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="index" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@gninmb" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="gninmb" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@uno" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="uno" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ocatd" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ocatd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_name" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_socr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="socr" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_socr" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="socr" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_code" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_index" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="index" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_index" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="index" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_gninmb" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="gninmb" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_gninmb" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="gninmb" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_uno" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="uno" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_uno" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="uno" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ocatd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ocatd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ocatd" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ocatd" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="name" DataSetColumn="name" />
              <Mapping SourceColumn="socr" DataSetColumn="socr" />
              <Mapping SourceColumn="code" DataSetColumn="code" />
              <Mapping SourceColumn="index" DataSetColumn="index" />
              <Mapping SourceColumn="gninmb" DataSetColumn="gninmb" />
              <Mapping SourceColumn="uno" DataSetColumn="uno" />
              <Mapping SourceColumn="ocatd" DataSetColumn="ocatd" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="kladrConnectionString (Settings)" DbObjectName="testlinq.Kladr.street" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillStreetByKladrCodeName" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataStreetByKladrCodeName" GeneratorSourceName="FillStreetByKladrCodeName" GetMethodModifier="Public" GetMethodName="GetDataStreetByKladrCodeName" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataStreetByKladrCodeName" UserSourceName="FillStreetByKladrCodeName">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        upper(name) as name, socr, code, [index], gninmb, uno, ocatd
FROM            Kladr.street
WHERE        (code LIKE @kladrcode + '____' + '00') AND (UPPER(name) LIKE @name)
ORDER BY name</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="kladrcode" ColumnName="code" DataSourceName="testlinq.Kladr.street" DataTypeServer="nchar(17)" DbType="String" Direction="Input" ParameterName="@kladrcode" Precision="0" ProviderType="NChar" Scale="0" Size="11" SourceColumn="code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="name" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="AnsiString" Direction="Input" ParameterName="@name" Precision="0" Scale="0" Size="1024" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="kladrConnectionString (Settings)" DbObjectName="testlinq.Kladr.street" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillStreetByKladrCodeNameSocr" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataStreetByKladrCodeNameSocr" GeneratorSourceName="FillStreetByKladrCodeNameSocr" GetMethodModifier="Public" GetMethodName="GetDataStreetByKladrCodeNameSocr" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataStreetByKladrCodeNameSocr" UserSourceName="FillStreetByKladrCodeNameSocr">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        UPPER(name) AS name, socr, code, [index], gninmb, uno, ocatd
FROM            Kladr.street
WHERE        (code LIKE @kladrcode + '____' + '00') AND (UPPER(name) LIKE @name) AND (UPPER(RTRIM(LTRIM(socr))) LIKE @socr)
ORDER BY name</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="kladrcode" ColumnName="code" DataSourceName="testlinq.Kladr.street" DataTypeServer="nchar(17)" DbType="String" Direction="Input" ParameterName="@kladrcode" Precision="0" ProviderType="NChar" Scale="0" Size="11" SourceColumn="code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="name" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="AnsiString" Direction="Input" ParameterName="@name" Precision="0" Scale="0" Size="1024" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="socr" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="AnsiString" Direction="Input" ParameterName="@socr" Precision="0" Scale="0" Size="1024" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="kladrDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="kladrDataSet" msprop:Generator_UserDSName="kladrDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="doma" msprop:Generator_TableClassName="domaDataTable" msprop:Generator_TableVarName="tabledoma" msprop:Generator_TablePropName="doma" msprop:Generator_RowDeletingName="domaRowDeleting" msprop:Generator_UserTableName="doma" msprop:Generator_RowChangingName="domaRowChanging" msprop:Generator_RowEvHandlerName="domaRowChangeEventHandler" msprop:Generator_RowDeletedName="domaRowDeleted" msprop:Generator_RowEvArgName="domaRowChangeEvent" msprop:Generator_RowChangedName="domaRowChanged" msprop:Generator_RowClassName="domaRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" msprop:Generator_UserColumnName="name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="korp" msprop:Generator_ColumnVarNameInTable="columnkorp" msprop:Generator_ColumnPropNameInRow="korp" msprop:Generator_ColumnPropNameInTable="korpColumn" msprop:Generator_UserColumnName="korp" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="socr" msprop:Generator_ColumnVarNameInTable="columnsocr" msprop:Generator_ColumnPropNameInRow="socr" msprop:Generator_ColumnPropNameInTable="socrColumn" msprop:Generator_UserColumnName="socr" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="code" msprop:Generator_ColumnVarNameInTable="columncode" msprop:Generator_ColumnPropNameInRow="code" msprop:Generator_ColumnPropNameInTable="codeColumn" msprop:Generator_UserColumnName="code">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="19" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="index" msprop:Generator_ColumnVarNameInTable="columnindex" msprop:Generator_ColumnPropNameInRow="index" msprop:Generator_ColumnPropNameInTable="indexColumn" msprop:Generator_UserColumnName="index" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="6" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="gninmb" msprop:Generator_ColumnVarNameInTable="columngninmb" msprop:Generator_ColumnPropNameInRow="gninmb" msprop:Generator_ColumnPropNameInTable="gninmbColumn" msprop:Generator_UserColumnName="gninmb" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="uno" msprop:Generator_ColumnVarNameInTable="columnuno" msprop:Generator_ColumnPropNameInRow="uno" msprop:Generator_ColumnPropNameInTable="unoColumn" msprop:Generator_UserColumnName="uno" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ocatd" msprop:Generator_ColumnVarNameInTable="columnocatd" msprop:Generator_ColumnPropNameInRow="ocatd" msprop:Generator_ColumnPropNameInTable="ocatdColumn" msprop:Generator_UserColumnName="ocatd" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="11" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="kladr" msprop:Generator_TableClassName="kladrDataTable" msprop:Generator_TableVarName="tablekladr" msprop:Generator_TablePropName="kladr" msprop:Generator_RowDeletingName="kladrRowDeleting" msprop:Generator_UserTableName="kladr" msprop:Generator_RowChangingName="kladrRowChanging" msprop:Generator_RowEvHandlerName="kladrRowChangeEventHandler" msprop:Generator_RowDeletedName="kladrRowDeleted" msprop:Generator_RowEvArgName="kladrRowChangeEvent" msprop:Generator_RowChangedName="kladrRowChanged" msprop:Generator_RowClassName="kladrRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" msprop:Generator_UserColumnName="name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="socr" msprop:Generator_ColumnVarNameInTable="columnsocr" msprop:Generator_ColumnPropNameInRow="socr" msprop:Generator_ColumnPropNameInTable="socrColumn" msprop:Generator_UserColumnName="socr" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="code" msprop:Generator_ColumnVarNameInTable="columncode" msprop:Generator_ColumnPropNameInRow="code" msprop:Generator_ColumnPropNameInTable="codeColumn" msprop:Generator_UserColumnName="code">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="13" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="index" msprop:Generator_ColumnVarNameInTable="columnindex" msprop:Generator_ColumnPropNameInRow="index" msprop:Generator_ColumnPropNameInTable="indexColumn" msprop:Generator_UserColumnName="index" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="6" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="gninmb" msprop:Generator_ColumnVarNameInTable="columngninmb" msprop:Generator_ColumnPropNameInRow="gninmb" msprop:Generator_ColumnPropNameInTable="gninmbColumn" msprop:Generator_UserColumnName="gninmb" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="uno" msprop:Generator_ColumnVarNameInTable="columnuno" msprop:Generator_ColumnPropNameInRow="uno" msprop:Generator_ColumnPropNameInTable="unoColumn" msprop:Generator_UserColumnName="uno" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ocatd" msprop:Generator_ColumnVarNameInTable="columnocatd" msprop:Generator_ColumnPropNameInRow="ocatd" msprop:Generator_ColumnPropNameInTable="ocatdColumn" msprop:Generator_UserColumnName="ocatd" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="11" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="status" msprop:Generator_ColumnVarNameInTable="columnstatus" msprop:Generator_ColumnPropNameInRow="status" msprop:Generator_ColumnPropNameInTable="statusColumn" msprop:Generator_UserColumnName="status" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="street" msprop:Generator_TableClassName="streetDataTable" msprop:Generator_TableVarName="tablestreet" msprop:Generator_TablePropName="street" msprop:Generator_RowDeletingName="streetRowDeleting" msprop:Generator_UserTableName="street" msprop:Generator_RowChangingName="streetRowChanging" msprop:Generator_RowEvHandlerName="streetRowChangeEventHandler" msprop:Generator_RowDeletedName="streetRowDeleted" msprop:Generator_RowEvArgName="streetRowChangeEvent" msprop:Generator_RowChangedName="streetRowChanged" msprop:Generator_RowClassName="streetRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" msprop:Generator_UserColumnName="name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="socr" msprop:Generator_ColumnVarNameInTable="columnsocr" msprop:Generator_ColumnPropNameInRow="socr" msprop:Generator_ColumnPropNameInTable="socrColumn" msprop:Generator_UserColumnName="socr" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="code" msprop:Generator_ColumnVarNameInTable="columncode" msprop:Generator_ColumnPropNameInRow="code" msprop:Generator_ColumnPropNameInTable="codeColumn" msprop:Generator_UserColumnName="code">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="17" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="index" msprop:Generator_ColumnVarNameInTable="columnindex" msprop:Generator_ColumnPropNameInRow="index" msprop:Generator_ColumnPropNameInTable="indexColumn" msprop:Generator_UserColumnName="index" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="6" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="gninmb" msprop:Generator_ColumnVarNameInTable="columngninmb" msprop:Generator_ColumnPropNameInRow="gninmb" msprop:Generator_ColumnPropNameInTable="gninmbColumn" msprop:Generator_UserColumnName="gninmb" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="uno" msprop:Generator_ColumnVarNameInTable="columnuno" msprop:Generator_ColumnPropNameInRow="uno" msprop:Generator_ColumnPropNameInTable="unoColumn" msprop:Generator_UserColumnName="uno" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ocatd" msprop:Generator_ColumnVarNameInTable="columnocatd" msprop:Generator_ColumnPropNameInRow="ocatd" msprop:Generator_ColumnPropNameInTable="ocatdColumn" msprop:Generator_UserColumnName="ocatd" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="11" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:doma" />
      <xs:field xpath="mstns:code" />
    </xs:unique>
    <xs:unique name="kladr_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:kladr" />
      <xs:field xpath="mstns:code" />
    </xs:unique>
    <xs:unique name="street_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:street" />
      <xs:field xpath="mstns:code" />
    </xs:unique>
  </xs:element>
</xs:schema>